[dbo].[asi_GetSystemEntityKeyForSourceCode]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GetSystemEntityKeyForSourceCode

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@SourceCodeKey	uniqueidentifier	16

SQL Script

CREATE Procedure asi_GetSystemEntityKeyForSourceCode
@SourceCodeKey uniqueidentifier
AS
SELECT TOP 1 SystemEntityKey FROM CampaignMain C
INNER JOIN AppealMain A ON C.CampaignKey = A.CampaignKey
INNER JOIN SolicitationMain S ON S.AppealKey = A.AppealKey
INNER JOIN SourceCode SC on SC.SolicitationKey = S.SolicitationKey
WHERE SourceCodeKey = @SourceCodeKey

GO

Uses

[dbo].[AppealMain]
[dbo].[CampaignMain]
[dbo].[SolicitationMain]
[dbo].[SourceCode]
dbo